ORACLE中怎样用正则表达式过滤中文字符答:if lengthb(substr(p_name,i,1))=2 then v_comma := instrb(v_code,',');v_code_q := to_number(substrb(v_code,1,v_comma-1));v_code_w := to_number(substrb(v_code,v_comma+1,abs(instrb(v_code,',',1,2)-v_comma-1)));if v_code_q>=176 and v_code_q<=247...
问一个关于数据库查询的为题!怎么获得小于当前年份固定月份的数据...答:select * from table where time like '%10'就可以获得TIME中以10结尾的数据,即每年10月的数据.要每年的话:(ORACLE)select substr(time,1,4),sum(sell) from TABLE group by substr(time,1,4)(SQL):select substring(time,1,4),sum(sell) from TABLE group by substr(time,1,4)就可以了...